how do i convert to single field

[madhubabum]

Hi All

    I have the following scenario,.......I have 2 Tables, 1. Depart & 2. Sales

   In that tables,Once we reload the Script.......In Table Viewer tool. I find Some common type of Same fields with different field names..

  How can i convert  into single single field.......

Thanks

Madhu

[jsingh71]

Use Concatenate in your load statement.

[amit_saini]

Madhu,

Check:

https://community.qlik.com/thread/41307

Thanks,

AS

[#4]

Hi Madhu,

if you have the same field from tow tables with slightly different names, you can alias these in your load script.

By doing that you will create a join on that field between your tables. You also have the option to alias and concatenate your two tables into a single common table.

LOAD

ID AS     Depart_ID

From

Depart.....

LOAD

SaleDepartID AS     Depart_ID

From

Sales.....

Hope that helps

Joe

[#5]

If fields are same you can join two tables on common fields by renaming them, better if you attached some data your tables.

[#6]

Failing that, post up some example script or QVW as that would be much easier to troubleshoot

[madhubabum]

Hi Joe Simmons

Thanks to ur reply.......

   In My Script i have more than one Common Fields in Two Tables

[#8]

Then concatenate may be your best option, like I say, uploading an example would be best to help.

You can alias multiple fields and concatenate your tables it sounds like though

[madhubabum]

Hi,

Then Link Table come into picture