Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Expression.Error: 5 arguments were passed to a function which expects between 3 and 4. Details:

Below is my coding:

 

= Table.FuzzyGroup(#"Changed Type",{"Name Keyword"}, {{"Count Name Keyword", each Table.RowCount(Table.Distinct(_)),Int64.Type}},[IgnoreCase = true, IgnoreSpace = true, Threshold = 0.42],{"Group By Name Keyword ", each _, type table [Name Keyword=nullable text, RecordTypeId=nullable text, BillingCountry=nullable text, ShippingCountry=nullable text, OwnerId=nullable text, Business_Unit__c=nullable text, National_Account__c=any, Status__c=nullable text, ADM_Geography__c=nullable text, Account_Customer_IDT__c=nullable number, Classification__c=nullable text, Entity_Description__c=any, Source_System__c=nullable text, Market_Segment__c=nullable text, Region__c=nullable text, SAP_ECC_Id__c=nullable number, Record Type.Name=nullable text]})

 

Hi all,

 

Current facing this error:

 

Expression.Error: 5 arguments were passed to a function which expects between 3 and 4.
Details:
Pattern=
Arguments=[List]

 

and have no idea how to fix it, your kind help will be greatly appreciated.

 

Thank you so much.

 

 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • Ehren's avatar
    Ehren
    Microsoft Employee
    3 years ago

    According to the docs, Table.FuzzyGroup can be passed up to four parameters: table, key, aggregatedColumns, and an optional options record.

     

    You're passing it five parameters.

    Table.FuzzyGroup(
    #"Changed Type",    // #1
    {"Name Keyword"},   // #2
    {
        {"Count Name Keyword", each Table.RowCount(Table.Distinct(_)),Int64.Type}
    },                  // #3
    [
        IgnoreCase = true,
        IgnoreSpace = true,
        Threshold = 0.42
    ],                  // #4
    {
        "Group By Name Keyword ",
        each _,
        type table [Name Keyword=nullable text, RecordTypeId=nullable text, BillingCountry=nullable text, ShippingCountry=nullable text, OwnerId=nullable text, Business_Unit__c=nullable text, National_Account__c=any, Status__c=nullable text, ADM_Geography__c=nullable text, Account_Customer_IDT__c=nullable number, Classification__c=nullable text, Entity_Description__c=any, Source_System__c=nullable text, Market_Segment__c=nullable text, Region__c=nullable text, SAP_ECC_Id__c=nullable number, Record Type.Name=nullable text]
    }                   // #5
)

    It looks like you may have started with a fuzzy group that just computed a count, but then added a new aggregated column ("Group By Name Keyword") at the end of the parameters, instead of adding it to the existing list of aggregated columns.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, 

       

      Thank you so much for your input. Do you happen to know the solution for this, if you do, do you mind sharing the correct codes with me?

       

      Thank you so much.

       

      With Regards,

       

      • Ehren's avatar
        Ehren
        Microsoft Employee
        3 years ago

        I'm not sure exactly what you're trying to do, but I suspect you need to move the "Group By Name Keyword" definition into the list of aggregated columns.

         

        Table.FuzzyGroup(
    #"Changed Type",
    {"Name Keyword"},
    {
        {
            "Count Name Keyword",
            each Table.RowCount(Table.Distinct(_)),
            Int64.Type
        },
        {
            "Group By Name Keyword ",
            each _,
            type table [Name Keyword=nullable text, RecordTypeId=nullable text, BillingCountry=nullable text, ShippingCountry=nullable text, OwnerId=nullable text, Business_Unit__c=nullable text, National_Account__c=any, Status__c=nullable text, ADM_Geography__c=nullable text, Account_Customer_IDT__c=nullable number, Classification__c=nullable text, Entity_Description__c=any, Source_System__c=nullable text, Market_Segment__c=nullable text, Region__c=nullable text, SAP_ECC_Id__c=nullable number, Record Type.Name=nullable text]
        }
    },
    [
        IgnoreCase = true,
        IgnoreSpace = true,
        Threshold = 0.42
    ]
)