topic Re: Re: Re: Merging tables with different fields in QlikView

Merging tables with different fields

Thu, 03 Oct 2013 20:58:58 GMT

Hi,

I have two fields as below:

Name	Value
Agreement_No	0000005238;ABC;123
Agreement_Desc	0000001234;PQR;456
Agreement_Amt	0000009876;XYZ;789

the first field is Descriptions and the second field is values.

I have separated descriptions to a separate table as below using script

Agreement_No	Agreement_Desc	Agreement_Amt
1	-	-
-	2	-
-	-	3

I have separated values to a separate table as below using script

field 1	field 2	field 3
0000005238	ABC	123
0000001234	PQR	456
0000009876	XYZ	789

Now, my final output should be as below. How can i achieve this?

I have tried using Concatenate but that does not help.

Agreement_No	Agreement_Desc	Agreement_Amt
0000005238	ABC	123
0000001234	PQR	456
0000009876	XYZ	789

Regards,

Vishal

Re: Merging tables with different fields

nicolett_yuri — Thu, 03 Oct 2013 22:17:44 GMT

Look at this example

Re: Re: Merging tables with different fields

Thu, 03 Oct 2013 22:36:36 GMT

Thanks for the response Yuri. I have field descriptions in one column and field values in another column. Using those two fields i am trying to create a table in Qlikview.

Your out treats everything as data.

Instead of having Table.A, TESTE, TESTE2 as column headers. I want Agreement_No, Agreement_Desc, Agreement_Amt as column header and the value in TESTE2 field above arranged as below.

Agreement_No	Agreement_Desc	Agreement_Amt
0000005238	ABC	123
0000001234	PQR	456
0000009876	XYZ	789

I am attaching the file, that i have used.

Please let me know your thoughts.

Vishal

Re: Re: Re: Merging tables with different fields

nicolett_yuri — Thu, 03 Oct 2013 23:16:08 GMT

Ok, try this!

Re: Merging tables with different fields

Fri, 04 Oct 2013 01:06:31 GMT

Hi Yuri,

That works perfect but just one more thing in here.

It works fine for static structure but flat file will have structure that will change depending on scenario.

for instance the flat file might have additional field and value.

EX:

Name	Value
Agreement_No	0000005238;ABC;123;Jan
Agreement_Desc	0000001234;PQR;456;Feb
Agreement_Amt	0000009876;XYZ;789;Mar
Period	0000001024;DEF;999;Apr

In such case, my output should be as below without changing the script:

Agreement_No	Agreement_Desc	Agreement_Amt	Period
0000005238	ABC	123	Jan
0000001234	PQR	456	Feb
0000009876	XYZ	789	Mar
0000001024	DEF	999	Apr

Please advice.

Thanks,

Vishal

Re: Re: Merging tables with different fields

Fri, 04 Oct 2013 06:19:05 GMT

This is how i was able to achieve it. PFA file.

Thanks a lot Yuri!.

Vishal

Re: Merging tables with different fields

nicolett_yuri — Fri, 04 Oct 2013 11:26:37 GMT

Very good!