Forum Discussion

thuy_resolve's avatar
thuy_resolve
Cloud Apps
07-30-2024
Solved

Can we edit the data without using code before pushing it to the Elasticube?

Hi guys! May I seek for your help to see, before we push the data into Elasticube, is there anyway we can edit the data without using code (just like remove column/row, add fields like the way we u...
administration
  • HamzaJ's avatar
    HamzaJ
    07-30-2024

    Hey thuy_resolve ,

    I dont think this is posisble. At least not for a CSV-file. I know for DB-connections you could write a query (which is code) to determine which columns to include or to do some transformations. 

    For a CSV you could drop the specific columns. Then they will not be imported by Sisense. That is the most low-code action I can think of

    Hamza

HamzaJ's avatar
HamzaJ
Data Integration
07-30-2024

Hey thuy_resolve ,

I dont think this is posisble. At least not for a CSV-file. I know for DB-connections you could write a query (which is code) to determine which columns to include or to do some transformations. 

For a CSV you could drop the specific columns. Then they will not be imported by Sisense. That is the most low-code action I can think of

Hamza

  • thuy_resolve's avatar
    thuy_resolve
    Cloud Apps
    07-30-2024

    Hi HamzaJ ,

    May I ask at the step of pushing the data into Elasticube where we can preview the data before BUILD, do you know where the temporary storage for preview data file be stored inside Sisense? 

    Thank you,

    Thuy

    • HamzaJ's avatar
      HamzaJ
      Data Integration
      07-30-2024

      I dont think it is stored anywhere. It is a real-time query of the file/database and shows the first x results. 

      So the file is the same as the file you uploaded