From Excel Worksheets to Scheduled Reporting

[@logandw5971]

best and ONLY channel for any foundry training. thank you so much team

[@dkfresh6656]

Thanks for the tutorial. Again learned something new. Keep the videos coming!!

[@chandradeepanand]

Thank you so much for this session!!! You explained really well. I am very excited to try it out. Thanks!

[@madfiskmad5904]

Great and detailed viz as allways. the video demostrates import and data transfomations done in Pipeline builder and then in Contour. But, could you also create a video on when to use Contour vs Pipeline builder after one has imported excel or csv to a give folder.

[@ratotinha]

Thank you so much for this tutorial! I would love to see a deep dive into the most useful, complex, and obscure transformations that can be used in Pipeline Builder. Anything that can make data cleaning easier would be greatly appreciated. For context, I will be doing a lot of data normalisation (e.g., using suppliers' names from different business units and normalising them so they can all link to a single output for analysis). Finding a logical way to obtain the most output data per supplier normalised link using only Foundry has been challenging for me as a Foundry novice.

[@dkfresh6656]

Hello again. I was following along with some data I’m working with in excel. When I got to the part to cast to different types the values are going null. The values are dollar amounts but uploaded as a string. When I try to cast to double the whole column goes to null. Tried decimal as well. Any ideas on how to get around this? Thanks!

[@GenaCoblentz]

Hi! Do the columns have any non-number characters in them? One thing you can try before you cast to a double is a regex replace to remove all non-number values from the column.

[@dkfresh6656]

@ thank you!!! A million thanks. Had to remove the comma. Y’all are the best 😀