uploading data from excel which is in different number formats

[raghavsurya]

Hi All,

We have a specific scenario wherein the data is avaliable in Excel sheet in two columns. The second column has information in different number/date formats.

For Example

Particulars Details

Country India

Date of commencement 14-Aug-2009

Revenue 14,00,000

and so on. How can we upload the these two columns in the exact format and represent the columns as a straight line chart to depict the data exactly.

Please let me know if you have come across similar situation.

Regards,

Raghav

[matt_crowther]

I've tested a similar dataset from Excel and try putting text(Details) round your Details field in the load script - this will bring the values in exactly as they are.

However the context may be lost so I recommend you check that depending on your ultimate usage.

Hope that helps.

Matt - Visual Analytics Ltd

[matt_crowther]

Raghav,

To maintain the context of the values you simply need to interpret them accordingly in the script; again I've tested on your data (ie Date, Number and Text in one column) and the below line of script pulls the data in as it appears in Excel but crucially maintains the context - ie text is text, numbers are numbers and Dates are recognised by Qv as Dates.

if(istext(Details),text(Details),if(left(text(Details),3)='*/',date(Details),Details)) as Details

Hope that helps,

Matt - Visual Analytics Ltd

[raghavsurya · Accepted solution]

Hi Matt,

Thanks a lot for your suggestion. It handles almost all the situations.

Thanks and Regards,

Raghav