DSXchange

Hi, I am in need of some help. Does anyone know if there is a relatively easy way to pivot 300 columns into rows within the one column. I have a file with 200,000 records and 300 columns. Does someone know of a better way to implement this solution other than using a Pivot Stage? If I use the pivot ...

That worked! Thank you so much for your help!

Jessica

Thanks for responding! One of the problems I am having is knowing how to correctly specify the date format within the function. I have tried all variations, but each time DS throws a parsing error. Here is an example of one my specifications. The specification is what I have entered in the Modify st...

Hello DS Experts! I'm trying to convert a date that is in a string datatype to a date datatype in a Modify stage, but am running into problems. The format of the string date value is different from the default format of "%yyyy-%mm-%dd", so I can't just use the "date_from_string(field_name)" specific...