Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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.

 

 

 

4 Replies
Highlighted
Partner
Partner

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;

Highlighted
Specialist III
Specialist III

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;
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Partner
Partner

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