topic Re: how do i convert to single field in QlikView

how do i convert to single field

madhubabum — Fri, 26 Jun 2015 11:12:08 GMT

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

Re: how do i convert to single field

jsingh71 — Fri, 26 Jun 2015 11:14:29 GMT

Use Concatenate in your load statement.

Re: how do i convert to single field

amit_saini — Fri, 26 Jun 2015 11:17:58 GMT

Madhu,

Check:

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

Thanks,

Re: how do i convert to single field

Fri, 26 Jun 2015 11:18:36 GMT

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

Re: how do i convert to single field

Fri, 26 Jun 2015 11:19:30 GMT

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

Re: how do i convert to single field

Fri, 26 Jun 2015 11:20:12 GMT

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

Re: how do i convert to single field

madhubabum — Fri, 26 Jun 2015 11:27:41 GMT

Hi Joe Simmons

Thanks to ur reply.......

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

Re: how do i convert to single field

Fri, 26 Jun 2015 11:30:00 GMT

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

Re: how do i convert to single field

madhubabum — Fri, 26 Jun 2015 12:36:00 GMT

Hi,

Then Link Table come into picture