data not stored in correct format.

[rupaliqlik]

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‌

[sunny_talwar]

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

[sunny_talwar]

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

[rupaliqlik]

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

[rupaliqlik]

YES

[sunny_talwar]

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.

[sunny_talwar]

Check here:

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

[Frank_Hartmann]

You will have to use a macro.

See here for workaround:

Keeping Leading Zero in Export

hope this helps

[trdandamudi]

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...

[m_woolf]

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.