Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert CSV-Date in new format

Hi,

 

i have a CSV File with a String information with following pattern dd.MM.yyyy i need to convert it to yyyy-MM-dd to import it into salesforce but i am not able to convert it. Could you please help me with my issue?

 

Thanks an best regards

 

Nuglo

Labels (1)
  • v6.x

1 Reply
Anonymous
Not applicable
Author

You can use tFileInput or similar component depending on type of your file. Map the contents or input data elements to output (Salesforce component) using tMap. You can use formatDate which should return a date string which corresponds to the format specified.