I am using Monarch 15 and when loading a database the headers are coming up F1, F2, etc. and the actual headers are in row 1. How do I make row 1 data the headers?
Are you using Monarch Classic or Data Prep Studio(DPS)? In Monarch Classic, click on the "Define and Import" button and you should see a check box that asks if the first row contains headers. If you click on the import button, you can click on the "Table Design" button and then select "Database" in the ribbon bar and then select the "First row contains column names" buttons. You will also need to click the little "Apply" green check mark followed by the green "Accept" check mark.
In DPS, after you have loaded your file, select Edit Load Options and then select the "First row has column names" check box.
Hi Jeff,
Are you using the data Prep Studio? If you are then this is the way to do it.....there are two screenshots below. Let me know if that helps.
Hi Jeff, Are you using the data Prep Studio? If you are then this is the way to do it.....there are two screenshots below. Let me know if that helps.
Thanks, this will work. I don’t usually use Data Prep Studio and I knew I had done this before in Monarch where there was a box that said use row 1 as header which I just checked but I can’t find it. Appreciate your help.
Thanks, this is what I was looking for.
