Skip to main content
Question

Need to export table data from Transformation Job by running SELECT statement.

  • March 31, 2022
  • 2 replies
  • 9 views
Z
Level 5

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

 

 

    2 replies

    .
    Level 11

    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.

    Z
    Level 5
    • z.b
    • Author
    • Level 5
    • April 12, 2022

    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

    Community Code of ConductAccessibility statement