6 Replies Latest reply on Jul 31, 2018 9:19 AM by Ankit Bansal

    Filtering after joining the data in SQL

    Imran Shaik

      Hi gurus, I have a requirement i need to join 4 data sources , each data source has more than 40 flat files without column(meta) data . so that i need to all the joining and required transformation in SQL. after joining for each flat file i would like to create new column like filename. and then each file have more than 5k records . my doubt is that for all the records that file name may be duplicated right. can i get the property of if user select one file name that respective property have to see its like quick filter on that created column file name .


      Even file names duplicated can we apply the property of quick filter .In filter window card it has distinct names . It's possible ?


      How to achieve good performance with enormous amount of records