Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need Date should be one feild

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

9 Replies
sunny_talwar

Is it possible that one csv file has timestamp and other one is just date?

Not applicable
Author

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, !

sunny_talwar

I don't see any attachments

Not applicable
Author

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

sunny_talwar

Check this out -> Uploading a Sample

avinashelite

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

Not applicable
Author

Sorry in my case on the top of menu there is no such Use Advanced Editor.

swuehl
MVP
MVP

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

Advanced topics for creating a qlik datamodel

More advanced topics of qlik datamodels

sunny_talwar

Have you looked at this post?

Uploading a Sample