Hi Team,
I need your help.
I have a table (T1) which has 5000 records. Wanted to extract all the records in CSV from the Transformation Job by the query (SELECT * FROM T1).
Problem :
In transformation job, I can only view 100 records.
Also the table is not in the data model, so I will bot be able to create an OLAP table in the analysis and download the data.
Please advice.
Regards,
JB
Hi @z.b , I would add the table in the Data Model without connecting it to any other table and then extract it as an OLAP table. As far as i know you can't extract a csv from the transformations.
Hi @1460067637 ,
Thank You. Had to do the way you have described.
However it would have been great to have such a feature in the transformation as introducing a table in the Data Model and loading it would consume APC .:-(
Regards,
JayB
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
