how to load multiple qvds with different column and successful concatenation without synthetic keys

[qliklearnervir]

Hi All,

I have a scenario where I have to load more than 10 QVDs and each QVD have some common and different field.

I have to concate these qvds and make an entry for all fields wither value or Null.

LIke :

QVD1

ID    ,Generation_ID  ,Detail_Expenses ,Purchase Flag

QVD2

ID    ,Generation_ID , Detail_Expenses ,Expense Flag

QVD3

ID    ,Generation_ID  ,Detail_Expenses ,Expense Flag  ,Control Flag       

similarly other QVDs have some common and other different filed.

i am following an approach to load the QVDs directly by using File and Next FIle approach but getting synthetic issue and every new QVD is creating as new table with bunch of synthetic keys.

please suggest the better option with programmatically , i don't want to type all table one after another.

[Arthur_Fong]

Try this:

QVD1:
load
ID    ,Generation_ID  ,Detail_Expenses ,Purchase Flag
from QVD1;

CONCATENATE

QVD2:
load
ID    ,Generation_ID , Detail_Expenses ,Expense Flag
from QVD2;

CONCATENATE

QVD3:
ID    ,Generation_ID  ,Detail_Expenses ,Expense Flag  ,Control Flag       
from QVD3;

[Saravanan_Desingh]

QVD:
Load ID, Generation_ID, Detail_Expenses, Purchase Flag
Resident QVD1;

Concatenate(QVD)
Load ID, Generation_ID, Detail_Expenses, Expense Flag
Resident QVD2;

Concatenate(QVD)
Load ID, Generation_ID, Detail_Expenses, Expense Flag, Control Flag       
Resident QVD3;

[Brett_Bleess]

If either of the two solutions you have received helped, we would appreciate it if you would close the thread by using the Accept as Solution button on the post(s) that helped.  This gives credit to the poster(s) and allows other Community Members to know what worked.  If you did something else to solve the issue, you can post what you did and then use the button to mark that post, and if you still have questions, please leave an update post.

Regards,
Brett

[marksouzacosta]

Hi,

We just released a new video in our YouTube channel related to your question.
I hope it helps!

IPC Tips - Removing Synthetic Keys
https://youtu.be/tETUxntiqew

Regards,

Mark Costa