🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Delete columns

User: "sara20"
sara20
Banned
Updated by Jocelyn
Hello 

When I want to import my data to RM at first I see RM understand duplicate columns so I can not import it to RM. It would be nice if I can import it to the RM then can delete duplicate columns. Also it would be nice if we could do association mining rule with Auto model.

regards
sara

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    User: "David_A"
    David_A
    New Altair Community Member
    Updated by David_A

    to handle duplicate column names during import you can do the following:

    • Don't define a header column (depending on the actual method, there is a checkbox for that in the wizard)
    • Then delete the duplicate column (for example with Select Attributes operator)
    • Use the Rename by Example Values operator to select the first row (which contains the original header names) to get back the original names
    • Afterwards you probably need to use Parse Numbers and Nominal to Date to get the correct value types for all attributes
    Best,
    David


    Edit:
    Even simpler is the option to rename the duplicate columns by hand while importing, but that's only feasible with a few duplicate names.

    User: "sara20"
    sara20
    Banned
    OP
    @David_A

    Thank you very much 

    This is big data and it is not possible to do any changes with hand. But other points are very useful

    Regards
    sara
Quick Links