topic Re: data not stored in correct format. in QlikView

data not stored in correct format.

rupaliqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have some set of data.when i stored it into csv it does not come into correct format while it display correct in table box.My user want data in correct format.I have attached my application .Please help me in this case.

What I Expect

BATCHNO	CHDRNUM	TRANO
01082017	10153685	1015368511082017
01082017	10203040	1020304011082017
01082017	10235263	1023526311082017

What QlikView store

1082017	10235263	1.02353E+15
1082017	10203040	1.0203E+15
1082017	10153685	1.01537E+15

Regards,

RUP

stalwar1‌kaushik.solanki‌jagan‌

Re: data not stored in correct format.

sunny_talwar — Tue, 01 Aug 2017 17:15:45 GMT

When I opened your QVW file, I saw this....

Re: data not stored in correct format.

sunny_talwar — Tue, 01 Aug 2017 17:18:05 GMT

I guess you are talking about the CSV file, are you?

Re: data not stored in correct format.

rupaliqlik — Tue, 01 Aug 2017 17:18:15 GMT

Hi,

In table box data comes in correct format but while storing it into csv it is not come into correct format.Kindly help.

Thanks in Advance

Regards,

RUP

Re: data not stored in correct format.

rupaliqlik — Tue, 01 Aug 2017 17:20:20 GMT

YES

Re: data not stored in correct format.

sunny_talwar — Tue, 01 Aug 2017 17:22:04 GMT

This is an Excel problem... it just the way it wants to format it... not sure if I can help you with that.... but may be someone else can.

Re: data not stored in correct format.

sunny_talwar — Tue, 01 Aug 2017 17:24:08 GMT

Check here:

Editing CSV file in Excel always converts number column to scientific notation - Super User

Re: data not stored in correct format.

Frank_Hartmann — Tue, 01 Aug 2017 17:43:23 GMT

You will have to use a macro.

See here for workaround:

Keeping Leading Zero in Export

hope this helps

Re: data not stored in correct format.

trdandamudi — Tue, 01 Aug 2017 17:55:40 GMT

You can try as below if you like the work around:

1) Run the below code

TEST:
LOAD DATE(TODAY(),'DDMMYYYY') AS BATCHNO,
CHDRNUM,
CHDRNUM&DATE(PTDATE,'DDMMYYYY') AS TRANO
FROM
C:\Users\COM\Desktop\TEST.xlsx
(ooxml, embedded labels, table is Sheet1);

STORE TEST INTO "TEST.CSV" (txt, delimiter is "\t");

2) Go to Excel. Click on "Data" and select "From Text"

3) When the Text Import Wizard popsup, Select Delimited and click on next

4) Put a check mark next to "Tab" and click on Next

5) Make sure you select "Text" for the three columns and click finish

Hope this helps...

Re: data not stored in correct format.

m_woolf — Tue, 01 Aug 2017 18:01:08 GMT

If you open the CSV with Notepad or Notepad++ you will see that the formatting of the csv file is correct.

The format changes when you open with Excel.

If you bring the data into Excel with the Data|From Text command, the wizard will prompt you for the delimiter and allow you to specify that each column is to be formatted as text. Then the data will appear as desired in Excel.