Combining 2 identical data sources

Hey all! I am dealing with a pretty archaic system to pull data from that I must extract in Excel format. I am pulling TWO separate Excels, with identical column structure, but different data. I have a Klip with a simple table built that works great based on one data set. However, I have to build two separate Klips since it's two separate data sources. Is there any way to combine these into a single data source, or use a formula within a Klip to combine them. Again, the column structures are identical, but two separate Excels.

Edit: I'm aware of the ability to merge, but that will not do what I am needing.



1 comment

  • 0
    Pratyusa Ray

    Hi Chase! 

    Thanks for the post.

    You can try using the LOOKUP function in this case.

    You can find more details here.

    Hope this helps!

    If you've got any questions, please feel free to log a support ticket with our team here! 

    Kind Regards,

    Pratyusa Ray

Please sign in to leave a comment.