How to store CSV data of Data loding (file) in Javascript variable?

[uz2020]

Hello, I'm Super Beginner.

How to store CSV data of Data loding (file) in Javascript variable?

Or can read the CSV file directly with JavaScript?

Thank you.

[ParthaSarathy · Accepted solution]

Hi @uz2020 ,

Lets say your Csv file contains 2 columns 'name' and 'email'. And internal name of your data loading (file) activity as 'fileImport'.

Next to your data loading activity, place a javaScript activity and try the below coding,

var query = xtk.queryDef.create(
<queryDef schema="temp:fileImport" operation="select">
<select>
<node expr="name"/>
<node expr="email"/>
</select>
</queryDef>
);
var record = query.ExecuteQuery();

for each (var variable in record) {
instance.vars.name = variable.name;
instance.vars.email= variable.email;
logInfo("Name is : "+instance.vars.name);
logInfo("Email is : "+instance.vars.email);
}

Regards,

ParthaSarathy S

[uz2020]

@ParthaSarathy I was able to do it. Thank you!

[vani97]

Continue on that how we can query for validating the email address in java script activity