Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
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
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