CSV File use as append

Sofia Rabin shared this idea 48 days ago
Awaiting Reply

Hi,

Currently in yellowfin we have an option to create reports with CSV entry filter.

We have many users that use this option but insert more than 1000 id's, at this point Yellowfin stuck and when the report start to run it take too long.

We created a tool on our servers that called "CSV Plus", the user upload CSV and get "File ID"

/18f8bd1be671e7f86dbae6b7645723ff


We have data model that contain the csv column values and the file id that the user have to use as filter:

/c4353b188d015e02ca1a24dd1e1fc9ab


When the user add as append the relevant data model (using inner join) the filtering is much faster.


Maybe we can have something like this that is part of Yellowfin application :)


Thanks,

Sofia

Comments (1)

photo
1

Hi Sofia,


I am a little unclear on how you would use this application. Would you mind sending thorough an example video recording to help illustrate the functionality? Feel free to send it via https://ftp.yellowfin.bi


This looks similar to a Transformation Flow where you are able to bring in data from a CSV source and apply transformation steps such as filtering (which is what I believe you are doing here). Let me know if this is the functionality that you are looking for!


Kind regards,

Simon