Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please check the script :
Kindly let me know its right or wrong:
ACC:
LOAD Acc_ID,
ACC_TYPE,
Last_Upd
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
join
LOAD Acc_ID,
Cust_#,
Prod_#
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
join
LOAD Cust_#,
F_Name,
L_Name,
State,
Region
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
join
LOAD ACC_ID,
Cust_# ,
Amt,
Txn_Dt,
Txn_ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Concatenate
LOAD ACC_ID,
Cust_#,
Amt,
Txn_Dt,
Txn_ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
If you have gone through above script : Transaction Incremental & Transaction table has same field .
Now i want date should be one common field.
By loading the above script if i select on any parameters it show two dates .
Can anyone correct me what i am doing wrong in this script.
Regards
Is it possible that one csv file has timestamp and other one is just date?
Hi Sunny,
Both the dates are same in both the CSV; there is no Time stamp.
Please find the attached files of it.
Can you help me out where i can attached the file as it cant be seen when i am replying to you.
Regards, !
I don't see any attachments
Hi,
Can you tell me where i can i attached the files.
as there is no attachment icon where i can attached the file..
Regards
Check this out -> Uploading a Sample
Once you click on reply at the top right you will find a menu Use advanced editor > once you click on that to the bottom right you will get the option to attach the document
Sorry in my case on the top of menu there is no such Use Advanced Editor.
Do you really want to JOIN first your incremental table, then concatenate your last file?
Or do you want to JOIN the already concatenated tables?
And assuming you want to use kind of an incremental load of your transaction data:
Don't you want to limit the historic data to the ones not contained in the incremental file update?
For example (and just as an example):
FACT:
LOAD ACC_ID,
Cust_# ,
Amt,
Txn_Dt,
Txn_ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Concatenate (FACT)
LOAD ACC_ID,
Cust_#,
Amt,
Txn_Dt,
Txn_ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE NOT EXISTS(Txn_ID); //
Then you can JOIN this single table to your other tables. Or maybe don't join it.
Why do you want to JOIN all tables into a single table at all?
Maybe have a look at:
Don't join - use Applymap instead
Get started with developing qlik datamodels
Have you looked at this post?