CSV File use as append

Sofia Rabin shared this idea 4 months ago
Completed

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 (3)

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

photo
1

Hi Sofia,


I'm just checking in to see if this is still a relevant issue for you.


Please let me know, providing some context as to how this would be different from the Transformation Flow mentioned in my previous message.


Kind regards,

Simon

photo
1

Hi Sofia,


I'm just messaging to let you know that I will be marking this as closed for the moment.


Feel free to respond here in order to re-open the ticket, and I will get back to you shortly.


Kind regards,

Simon