CSV File use as append

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

Replies (0)

Leave a Comment
 
Attach a file