topic Re: I need Date should be one feild in QlikView

I need Date should be one feild

Thu, 21 Apr 2016 07:57:49 GMT

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

Re: I need Date should be one feild

sunny_talwar — Thu, 21 Apr 2016 15:14:29 GMT

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

Re: I need Date should be one feild

Fri, 22 Apr 2016 05:20:18 GMT

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

Re: I need Date should be one feild

sunny_talwar — Fri, 22 Apr 2016 09:43:59 GMT

I don't see any attachments

Re: I need Date should be one feild

Fri, 22 Apr 2016 09:58:22 GMT

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

Re: I need Date should be one feild

sunny_talwar — Fri, 22 Apr 2016 10:41:07 GMT

Check this out -> Uploading a Sample

Re: I need Date should be one feild

avinashelite — Fri, 22 Apr 2016 11:09:31 GMT

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

Re: I need Date should be one feild

Fri, 22 Apr 2016 11:17:30 GMT

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

Re: I need Date should be one feild

swuehl — Fri, 22 Apr 2016 11:21:06 GMT

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

Re: I need Date should be one feild

sunny_talwar — Fri, 22 Apr 2016 12:52:52 GMT

Have you looked at this post?

Uploading a Sample