<div>
Hi, 
Unfortunately I have to use this format. This is a one time execution to create a new table, therefore speed is not an issue. Do know the VB.NET syntax to achieve this? 
Thanks 
Victor
</div>

Hi,
Unfortunately I have to use this format. This is a one time execution to create a new table, therefore speed is not an issue. Do know the VB.NET syntax to achieve this?
Thanks
Victor

<div>
<div class="content wysiwyg-content">
Hi, 
 
 
 
I have two tables created from 2 xml files which are linked by the NSC column, How do I create a new table with data from table2 by merging data from table2 to table1, where the fields from table2 are included in table1, for example if table1 contains 
 
NSC: &nbsp; F1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F2 
 
1 &nbsp; &nbsp; &nbsp; &nbsp; AGD, AGD1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AGD 
 
2 &nbsp; &nbsp; &nbsp; &nbsp;AGD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AGD, AGD1 
 
 
 
table2 contains: 
 
NSC: &nbsp; AGD &nbsp; AGD1 
 
1 &nbsp; &nbsp; &nbsp; &nbsp; XXX &nbsp; &nbsp;YYY 
 
2 &nbsp; &nbsp; &nbsp; &nbsp;ZZZ &nbsp; &nbsp;WWW 
 
 
 
How do I create table3? 
 
 
 
NSC: &nbsp; F1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F2 
 
1 &nbsp; &nbsp; &nbsp; &nbsp; XXX;YYY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXX 
 
2 &nbsp; &nbsp; &nbsp; &nbsp;XXX &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXX;YYY 
 
 
Thanks, 
 
Victor
</div>
</div>

Hi,



I have two tables created from 2 xml files which are linked by the NSC column, How do I create a new table with data from table2 by merging data from table2 to table1, where the fields from table2 are included in table1, for example if table1 contains

NSC:   F1                            F2

1         AGD, AGD1            AGD

2        AGD                        AGD, AGD1



table2 contains:

NSC:   AGD   AGD1

1         XXX    YYY

2        ZZZ    WWW



How do I create table3?



NSC:   F1                            F2

1         XXX;YYY                XXX

2        XXX                        XXX;YYY


Thanks,

Victor

Help with merging data from 2 tables using VB.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.