Rejoining Two CSV's

I avoided the CSV import limit of 100mb by splitting my CSV into two sections and then uploading them to Sigma. The problem is now that I want to combine these two CSV’s, is there any way to go about this?

Hey Zachary!

You can do this by doing a UNION join in SQL Runner – I’ll list the steps below.

  1. Convert both of the CSV’s into datasets.

  2. Use the Dataset View Path name to call out those datasets in SQL runner.

  3. Use UNION ALL to join the two worksheets together.
    Select * from View_Dataset1
    UNION ALL
    Select * from View_Dataset2