CSV File use as append

Sofia Rabin shared this idea 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

I like this idea 0

Comments (3)

Simon ● 14 months ago

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

Reply URL

Simon ● 10 months ago

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

Reply URL

Simon ● 9 months ago

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

Reply URL