Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

error in boosted and forest models?!

dalilo99
6 - Meteoroid

Dear all,

I have been working on this project for a while, and i kept stumbling upon a problem that tired me.

when i run my workflow, i receive 6 errors:

boosted:

Error: Boosted Model (28): Boosted Model: Error in checkForRemoteErrors(val) :
Error: Boosted Model (28): Boosted Model: Execution halted
Error: Boosted Model (28): Boosted Model: The R.exe exit code (1) indicated an error.

 

forest: 

Warning: Forest Model (35): 350 records were omitted due to missing values
Error: Forest Model (35): Forest Model: Error in randomForest.default(m, y, ...) :
Error: Forest Model (35): Forest Model: Execution halted
Error: Forest Model (35): Forest Model: The R.exe exit code (1) indicated an error.

 

Keeping in mind that i did clean up the data, and imputed some.

can someone please help me on this matter?

I will attach my workflow below.

 

thank you

 

-Dalal

8 REPLIES 8
danilang
19 - Altair
19 - Altair

Hi @dalilo99 

 

Can you attach the input file, "Credit-data-training.xlsx"?  

 

Dan

dalilo99
6 - Meteoroid

Sure

AndrewKramer
Alteryx Alumni (Retired)

Can you enable 'Show all macro messages' and let us know what you see?

AndrewKramer_0-1580150475005.png

dalilo99
6 - Meteoroid

Start: Designer x64: Started running C:\Users\abdullah\Desktop\Project 4 fixed.yxmd at 01/27/2020 21:49:37
Info: Decision Tree (29): Tool #247: 1 record was output
Info: Decision Tree (29): Tool #256: 1 record was output
Info: Imputation (3): Dynamic Metadata (261): Tool #31: Text Input (1): 1 record was output
Info: Imputation (3): Dynamic Metadata (261): Tool #32: Text Input (1): 1 record was output
File_Input: Input Data (1): C:\Users\abdullah\Desktop\credit-data-training.xlsx|500 records were read from "C:\Users\abdullah\Desktop\credit-data-training.xlsx" (`Sheet1$`)
Info: Auto Field (2): The FieldType of "Credit-Application-Result" changed to: String(16)
Info: Auto Field (2): The FieldType of "Account-Balance" changed to: String(12)
Info: Auto Field (2): The FieldType of "Payment-Status-of-Previous-Credit" changed to: V_String(26)
Info: Auto Field (2): The FieldType of "Purpose" changed to: String(12)
Info: Auto Field (2): The FieldType of "Value-Savings-Stocks" changed to: String(10)
Info: Auto Field (2): The FieldType of "No-of-Credits-at-this-Bank" changed to: V_String(11)
Warning: Imputation (3): Tool #156: The field "_nulls" is not present in all inputs.
Warning: Imputation (3): Tool #156: The field "_records" is not present in all inputs.
Warning: Imputation (3): Tool #191: The field "_name" is not present in all inputs.
Warning: Imputation (3): Tool #191: The field "_Size" is not present in all inputs.
Warning: Imputation (3): Tool #191: The field "_Type" is not present in all inputs.
Info: Imputation (3): Tool #178: 16 rows were generated
Info: Imputation (3): Tool #153: 0 records were True and 500 were False
Info: Imputation (3): Tool #93: 0 records were summarized to 0 groups
Info: Imputation (3): Tool #94: 500 records were summarized to 1 groups
Info: Imputation (3): Tool #95: 0 records were joined with 0 un-joined left records and 1 un-joined right records
Info: Imputation (3): Tool #154: 500 records were summarized to 1 groups
Info: Imputation (3): Tool #158: 1 records were True and 3 were False
Info: Imputation (3): Tool #155: 0 records were joined with 0 un-joined left records and 1 un-joined right records
Info: Imputation (3): Tool #205: 0 records were True and 1 were False
Info: Imputation (3): Tool #208: 0 records were joined with 0 un-joined left records and 16 un-joined right records
Info: Imputation (3): Tool #183: 2 rows were generated
Info: Imputation (3): Tool #186: 16 records were summarized to 16 groups
Info: Imputation (3): Dynamic Metadata (261): Tool #25: 16 records were summarized to 1 groups
Info: Imputation (3): Dynamic Metadata (261): Tool #30: 14 records were joined with 2 un-joined left records and 1 un-joined right records
Info: Imputation (3): Dynamic Metadata (261): Tool #31: Summarize (3): 2 records were summarized to 1 groups
Info: Imputation (3): Dynamic Metadata (261): Tool #32: Summarize (3): 1 records were summarized to 1 groups
Info: Imputation (3): Dynamic Metadata (261): Tool #33: 1 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Imputation (3): Tool #174: 14 records were joined with 486 un-joined left records and 0 un-joined right records
Info: Imputation (3): Tool #166: 500 records were output
Warning: Imputation (3): Dynamic Metadata (261): Tool #77: Record #1: Tool #1: The field "Age-years_Indicator" is not contained in the record.
Warning: Imputation (3): Dynamic Metadata (261): Tool #77: Record #1: Tool #1: The field "Age-years_ImputedValue" is not contained in the record.
Info: Imputation (3): Dynamic Metadata (261): Tool #77: 1 iterations were run
Info: Imputation (3): Tool #264: 500 records were joined with 0 un-joined left records and 0 un-joined right records
File_Output: Browse (5): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_8b1ea0d201074252a084625c57d2fb9f_.yxdb|500 records
Info: Create Samples (4): Tool #16: 500 records were summarized to 1 groups
Warning: Logistic Regression (7): Tool #24: The field "Age_years" is not contained in the record.
Info: Create Samples (4): Tool #17: 500 target records generated 500 output records
Info: Create Samples (4): Tool #44: 500 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Create Samples (4): Tool #45: 350 records were True and 150 were False
Info: Logistic Regression (7): Tool #34: 350 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Logistic Regression (7): Logistic Regression: R version 3.5.3 (2019-03-11) - x86_64
Info: Logistic Regression (7): Logistic Regression: Loading required package: sysfonts
Info: Logistic Regression (7): Logistic Regression: Loading required package: showtextdb
Info: Logistic Regression (7): Logistic Regression: rgeos version: 0.4-2, (SVN revision 581)
Info: Logistic Regression (7): Logistic Regression: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Logistic Regression (7): Logistic Regression: Linking to sp version: 1.3-1
Info: Logistic Regression (7): Logistic Regression: Polygon checking: TRUE
Info: Logistic Regression (7): Logistic Regression: Attaching package: 'AlteryxPredictive'
Info: Logistic Regression (7): Logistic Regression: The following object is masked from 'package:AlteryxRDataX':
Info: Logistic Regression (7): Logistic Regression: XMSG
Info: Logistic Regression (7): Logistic Regression: Loading required namespace: car
Info: Logistic Regression (7): Logistic Regression: Attaching package: 'inline'
Info: Logistic Regression (7): Logistic Regression: The following object is masked from 'package:Rcpp':
Info: Logistic Regression (7): Logistic Regression: registerPlugin
Warning: Logistic Regression (7): Logistic Regression: In if (the.column[[1]][[1]] == "POINT EMPTY") return(3) :
Info: Logistic Regression (7): Logistic Regression: the condition has length > 1 and only the first element will be used
Info: Logistic Regression (7): Tool #214: Tool #2: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #4: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #9: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #13: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #16: 18 records were True and 25 were False
Info: Logistic Regression (7): Tool #214: Tool #23: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #66: 1 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Logistic Regression (7): Tool #214: Tool #27: 3 records were True and 40 were False
Info: Logistic Regression (7): Tool #214: Tool #34: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #81: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #214: Tool #86: 1 records were output
Info: Logistic Regression (7): Tool #215: Tool #3: 1 records were True and 42 were False
Info: Logistic Regression (7): Tool #215: Tool #6: 12 records were True and 31 were False
Info: Logistic Regression (7): Tool #215: Tool #12: 1 records were output
Info: Logistic Regression (7): Tool #127: R version 3.5.3 (2019-03-11) - x86_64
Info: Logistic Regression (7): Tool #127: Loading required package: sysfonts
Info: Logistic Regression (7): Tool #127: Loading required package: showtextdb
Info: Logistic Regression (7): Tool #127: rgeos version: 0.4-2, (SVN revision 581)
Info: Logistic Regression (7): Tool #127: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Logistic Regression (7): Tool #127: Linking to sp version: 1.3-1
Info: Logistic Regression (7): Tool #127: Polygon checking: TRUE
Info: Logistic Regression (7): Tool #127: Attaching package: 'AlteryxPredictive'
Info: Logistic Regression (7): Tool #127: The following object is masked from 'package:AlteryxRDataX':
Info: Logistic Regression (7): Tool #127: XMSG
Info: Logistic Regression (7): Tool #127: Attaching package: 'inline'
Info: Logistic Regression (7): Tool #127: The following object is masked from 'package:Rcpp':
Info: Logistic Regression (7): Tool #127: registerPlugin
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable Account.Balance' because it was categorical."
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable Payment.Status.of.Previous.Credit' because it was categorical."
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable Purpose' because it was categorical."
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable Value.Savings.Stocks' because it was categorical."
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable Length.of.current.employment' because it was categorical."
Info: Logistic Regression (7): Tool #127: [1] "Conditional-density plot not generated for variable No.of.Credits.at.this.Bank' because it was categorical."
Warning: Logistic Regression (7): Tool #127: In strwidth(title, cex = cex, units = "in") :
Info: Logistic Regression (7): Tool #127: font family 'yxfont' not found in PostScript font database
Warning: Logistic Regression (7): Tool #127: In readLines(x, warn = F) :
Info: Logistic Regression (7): Tool #127: invalid input found on input connection 'C:/Users/abdullah/AppData/Local/Alteryx/R-3.5.3/library/flightdeck/htmlwidgets/lib/bootbox/bootbox.min.js'
Info: Logistic Regression (7): Tool #128: 13 target records generated 13 output records
Info: Logistic Regression (7): Tool #129: 0 records were True and 13 were False
Info: Logistic Regression (7): Tool #132: 0 records were True and 0 were False
Info: Stepwise (8): Tool #5: R version 3.5.3 (2019-03-11) - x86_64
Info: Stepwise (8): Tool #5: Loading required package: sysfonts
Info: Stepwise (8): Tool #5: Loading required package: showtextdb
Info: Stepwise (8): Tool #5: rgeos version: 0.4-2, (SVN revision 581)
Info: Stepwise (8): Tool #5: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Stepwise (8): Tool #5: Linking to sp version: 1.3-1
Info: Stepwise (8): Tool #5: Polygon checking: TRUE
Info: Stepwise (8): Tool #5: Attaching package: 'AlteryxPredictive'
Info: Stepwise (8): Tool #5: The following object is masked from 'package:AlteryxRDataX':
Info: Stepwise (8): Tool #5: XMSG
Info: Stepwise (8): Tool #5: Loading required package: carData
Info: Stepwise (8): Tool #5: Read 1 item
Info: Stepwise (8): Tool #5: Start: AIC=359.15
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Duration.of.Credit.Month +
Info: Stepwise (8): Tool #5: Payment.Status.of.Previous.Credit + Purpose + Credit.Amount +
Info: Stepwise (8): Tool #5: Value.Savings.Stocks + Length.of.current.employment + Instalment.per.cent +
Info: Stepwise (8): Tool #5: Most.valuable.available.asset + Age.years + Type.of.apartment +
Info: Stepwise (8): Tool #5: No.of.Credits.at.this.Bank
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: - Age.years 1 323.17 357.17
Info: Stepwise (8): Tool #5: - Duration.of.Credit.Month 1 323.48 357.48
Info: Stepwise (8): Tool #5: - Value.Savings.Stocks 2 325.83 357.83
Info: Stepwise (8): Tool #5: - No.of.Credits.at.this.Bank 1 324.00 358.00
Info: Stepwise (8): Tool #5: - Type.of.apartment 1 324.40 358.40
Info: Stepwise (8): Tool #5: <none> 323.15 359.15
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 327.61 359.61
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 329.04 361.04
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 327.76 361.76
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 328.40 362.40
Info: Stepwise (8): Tool #5: - Credit.Amount 1 329.84 363.84
Info: Stepwise (8): Tool #5: - Purpose 3 335.46 365.46
Info: Stepwise (8): Tool #5: - Account.Balance 1 348.66 382.66
Info: Stepwise (8): Tool #5: Step: AIC=357.17
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Duration.of.Credit.Month +
Info: Stepwise (8): Tool #5: Payment.Status.of.Previous.Credit + Purpose + Credit.Amount +
Info: Stepwise (8): Tool #5: Value.Savings.Stocks + Length.of.current.employment + Instalment.per.cent +
Info: Stepwise (8): Tool #5: Most.valuable.available.asset + Type.of.apartment + No.of.Credits.at.this.Bank
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: - Duration.of.Credit.Month 1 323.53 355.53
Info: Stepwise (8): Tool #5: - Value.Savings.Stocks 2 325.84 355.84
Info: Stepwise (8): Tool #5: - No.of.Credits.at.this.Bank 1 324.01 356.01
Info: Stepwise (8): Tool #5: - Type.of.apartment 1 324.63 356.63
Info: Stepwise (8): Tool #5: <none> 323.17 357.17
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 327.79 357.79
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 329.11 359.11
Info: Stepwise (8): Tool #5: + Age.years 1 323.15 359.15
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 327.81 359.81
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 328.42 360.42
Info: Stepwise (8): Tool #5: - Credit.Amount 1 329.95 361.95
Info: Stepwise (8): Tool #5: - Purpose 3 335.46 363.46
Info: Stepwise (8): Tool #5: - Account.Balance 1 348.67 380.67
Info: Stepwise (8): Tool #5: Step: AIC=355.53
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Payment.Status.of.Previous.Credit +
Info: Stepwise (8): Tool #5: Purpose + Credit.Amount + Value.Savings.Stocks + Length.of.current.employment +
Info: Stepwise (8): Tool #5: Instalment.per.cent + Most.valuable.available.asset + Type.of.apartment +
Info: Stepwise (8): Tool #5: No.of.Credits.at.this.Bank
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: - Value.Savings.Stocks 2 326.12 354.12
Info: Stepwise (8): Tool #5: - No.of.Credits.at.this.Bank 1 324.28 354.28
Info: Stepwise (8): Tool #5: - Type.of.apartment 1 324.98 354.98
Info: Stepwise (8): Tool #5: <none> 323.53 355.53
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 328.10 356.10
Info: Stepwise (8): Tool #5: + Duration.of.Credit.Month 1 323.17 357.17
Info: Stepwise (8): Tool #5: + Age.years 1 323.48 357.48
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 329.60 357.60
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 328.72 358.72
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 329.51 359.51
Info: Stepwise (8): Tool #5: - Purpose 3 336.03 362.03
Info: Stepwise (8): Tool #5: - Credit.Amount 1 334.60 364.60
Info: Stepwise (8): Tool #5: - Account.Balance 1 348.88 378.88
Info: Stepwise (8): Tool #5: Step: AIC=354.12
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Payment.Status.of.Previous.Credit +
Info: Stepwise (8): Tool #5: Purpose + Credit.Amount + Length.of.current.employment +
Info: Stepwise (8): Tool #5: Instalment.per.cent + Most.valuable.available.asset + Type.of.apartment +
Info: Stepwise (8): Tool #5: No.of.Credits.at.this.Bank
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: - No.of.Credits.at.this.Bank 1 327.14 353.14
Info: Stepwise (8): Tool #5: - Type.of.apartment 1 327.33 353.33
Info: Stepwise (8): Tool #5: <none> 326.12 354.12
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 331.29 355.29
Info: Stepwise (8): Tool #5: + Value.Savings.Stocks 2 323.53 355.53
Info: Stepwise (8): Tool #5: + Duration.of.Credit.Month 1 325.84 355.84
Info: Stepwise (8): Tool #5: + Age.years 1 326.09 356.09
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 332.36 356.36
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 330.70 356.70
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 332.04 358.04
Info: Stepwise (8): Tool #5: - Purpose 3 338.37 360.37
Info: Stepwise (8): Tool #5: - Credit.Amount 1 337.47 363.47
Info: Stepwise (8): Tool #5: - Account.Balance 1 355.75 381.75
Info: Stepwise (8): Tool #5: Step: AIC=353.14
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Payment.Status.of.Previous.Credit +
Info: Stepwise (8): Tool #5: Purpose + Credit.Amount + Length.of.current.employment +
Info: Stepwise (8): Tool #5: Instalment.per.cent + Most.valuable.available.asset + Type.of.apartment
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: - Type.of.apartment 1 328.55 352.55
Info: Stepwise (8): Tool #5: <none> 327.14 353.14
Info: Stepwise (8): Tool #5: + No.of.Credits.at.this.Bank 1 326.12 354.12
Info: Stepwise (8): Tool #5: + Value.Savings.Stocks 2 324.28 354.28
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 332.40 354.40
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 332.58 354.58
Info: Stepwise (8): Tool #5: + Duration.of.Credit.Month 1 326.97 354.97
Info: Stepwise (8): Tool #5: + Age.years 1 327.13 355.13
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 331.70 355.70
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 332.87 356.87
Info: Stepwise (8): Tool #5: - Purpose 3 339.66 359.66
Info: Stepwise (8): Tool #5: - Credit.Amount 1 337.94 361.94
Info: Stepwise (8): Tool #5: - Account.Balance 1 355.83 379.83
Info: Stepwise (8): Tool #5: Step: AIC=352.55
Info: Stepwise (8): Tool #5: Credit.Application.Result ~ Account.Balance + Payment.Status.of.Previous.Credit +
Info: Stepwise (8): Tool #5: Purpose + Credit.Amount + Length.of.current.employment +
Info: Stepwise (8): Tool #5: Instalment.per.cent + Most.valuable.available.asset
Info: Stepwise (8): Tool #5: Df Deviance AIC
Info: Stepwise (8): Tool #5: <none> 328.55 352.55
Info: Stepwise (8): Tool #5: + Type.of.apartment 1 327.14 353.14
Info: Stepwise (8): Tool #5: + No.of.Credits.at.this.Bank 1 327.33 353.33
Info: Stepwise (8): Tool #5: + Value.Savings.Stocks 2 325.89 353.89
Info: Stepwise (8): Tool #5: - Most.valuable.available.asset 1 332.06 354.06
Info: Stepwise (8): Tool #5: - Length.of.current.employment 2 334.07 354.07
Info: Stepwise (8): Tool #5: - Payment.Status.of.Previous.Credit 2 334.24 354.24
Info: Stepwise (8): Tool #5: + Age.years 1 328.38 354.38
Info: Stepwise (8): Tool #5: + Duration.of.Credit.Month 1 328.38 354.38
Info: Stepwise (8): Tool #5: - Instalment.per.cent 1 333.75 355.75
Info: Stepwise (8): Tool #5: - Purpose 3 340.77 358.77
Info: Stepwise (8): Tool #5: - Credit.Amount 1 338.43 360.43
Info: Stepwise (8): Tool #5: - Account.Balance 1 359.68 381.68
Info: Stepwise (8): Tool #5: Attaching package: 'inline'
Info: Stepwise (8): Tool #5: The following object is masked from 'package:Rcpp':
Info: Stepwise (8): Tool #5: registerPlugin
Info: Stepwise (8): Tool #5: Analysis of Deviance Table (Type II tests)
Info: Stepwise (8): Tool #5: Response: Credit.Application.Result
Info: Stepwise (8): Tool #5: LR Chisq Df Pr(>Chisq)
Info: Stepwise (8): Tool #5: Account.Balance 31.1292 1 2.414e-08 ***
Info: Stepwise (8): Tool #5: Payment.Status.of.Previous.Credit 5.6868 2 0.058227 .
Info: Stepwise (8): Tool #5: Purpose 12.2248 3 0.006651 **
Info: Stepwise (8): Tool #5: Credit.Amount 9.8824 1 0.001669 **
Info: Stepwise (8): Tool #5: Length.of.current.employment 5.5216 2 0.063240 .
Info: Stepwise (8): Tool #5: Instalment.per.cent 5.1979 1 0.022614 *
Info: Stepwise (8): Tool #5: Most.valuable.available.asset 3.5090 1 0.061036 .
Info: Stepwise (8): Tool #5: ---
Info: Stepwise (8): Tool #5: Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Warning: Stepwise (8): Tool #5: In if (the.column[[1]][[1]] == "POINT EMPTY") return(3) :
Info: Stepwise (8): Tool #5: the condition has length > 1 and only the first element will be used
Info: Stepwise (8): Tool #34: 1 records were True and 31 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #2: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #4: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #9: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #13: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #16: 12 records were True and 19 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #23: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #66: 1 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #27: 3 records were True and 28 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #34: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #81: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #9: Tool #86: 1 records were output
Info: Stepwise (8): Tool #35: Record #1: Tool #10: Tool #3: 1 records were True and 30 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #10: Tool #6: 7 records were True and 24 were False
Info: Stepwise (8): Tool #35: Record #1: Tool #10: Tool #12: 1 records were output
Warning: Stepwise (8): Tool #35: Record #1: Tool #16: The field "Type" is not present in all inputs.
Info: Stepwise (8): Tool #35: 1 iterations were run
File_Output: Browse (9): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_beac13e4f98049bb948d9b560ef66641_.yxdb|1 records
Info: Stepwise (8): Tool #74: R version 3.5.3 (2019-03-11) - x86_64
Info: Stepwise (8): Tool #74: Loading required package: sysfonts
Info: Stepwise (8): Tool #74: Loading required package: showtextdb
Info: Stepwise (8): Tool #74: rgeos version: 0.4-2, (SVN revision 581)
Info: Stepwise (8): Tool #74: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Stepwise (8): Tool #74: Linking to sp version: 1.3-1
Info: Stepwise (8): Tool #74: Polygon checking: TRUE
Info: Stepwise (8): Tool #74: Attaching package: 'AlteryxPredictive'
Info: Stepwise (8): Tool #74: The following object is masked from 'package:AlteryxRDataX':
Info: Stepwise (8): Tool #74: XMSG
Info: Stepwise (8): Tool #75: 13 target records generated 13 output records
Info: Stepwise (8): Tool #76: 0 records were True and 13 were False
Info: Stepwise (8): Tool #79: 0 records were True and 0 were False
Info: Stepwise (8): Tool #80: 0 records were True and 13 were False
Info: Stepwise (8): Tool #81: 0 records were True and 0 were False
File_Output: Browse (10): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_f83260448a48470dbf2a8ba16e9a6033_.yxdb|13 records
Info: Boosted Model (28): Tool #12: 350 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Boosted Model (28): Boosted Model: R version 3.5.3 (2019-03-11) - x86_64
Info: Boosted Model (28): Boosted Model: Loading required package: sysfonts
Info: Boosted Model (28): Boosted Model: Loading required package: showtextdb
Info: Boosted Model (28): Boosted Model: rgeos version: 0.4-2, (SVN revision 581)
Info: Boosted Model (28): Boosted Model: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Boosted Model (28): Boosted Model: Linking to sp version: 1.3-1
Info: Boosted Model (28): Boosted Model: Polygon checking: TRUE
Info: Boosted Model (28): Boosted Model: Attaching package: 'AlteryxPredictive'
Info: Boosted Model (28): Boosted Model: The following object is masked from 'package:AlteryxRDataX':
Info: Boosted Model (28): Boosted Model: XMSG
Info: Boosted Model (28): Boosted Model: Loaded gbm 2.1.5
Error: Boosted Model (28): Boosted Model: Error in checkForRemoteErrors(val) :
Info: Boosted Model (28): Boosted Model: one node produced an error: variable 13: Age.years_ImputedValue has only missing values.
Info: Boosted Model (28): Boosted Model: Calls: eval ... clusterApply -> staticClusterApply -> checkForRemoteErrors
Error: Boosted Model (28): Boosted Model: Execution halted
Info: Boosted Model (28): Tool #42: 0 records were True and 0 were False
Info: Boosted Model (28): Tool #43: 0 records were True and 0 were False
Error: Boosted Model (28): Boosted Model: The R.exe exit code (1) indicated an error.
Info: Decision Tree (29): Tool #87: 350 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Decision Tree (29): Decision Tree: R version 3.5.3 (2019-03-11) - x86_64
Info: Decision Tree (29): Decision Tree: Loading required package: sysfonts
Info: Decision Tree (29): Decision Tree: Loading required package: showtextdb
Info: Decision Tree (29): Decision Tree: rgeos version: 0.4-2, (SVN revision 581)
Info: Decision Tree (29): Decision Tree: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Decision Tree (29): Decision Tree: Linking to sp version: 1.3-1
Info: Decision Tree (29): Decision Tree: Polygon checking: TRUE
Info: Decision Tree (29): Decision Tree: Attaching package: 'AlteryxPredictive'
Info: Decision Tree (29): Decision Tree: The following object is masked from 'package:AlteryxRDataX':
Info: Decision Tree (29): Decision Tree: XMSG
Info: Decision Tree (29): Decision Tree: Attaching package: 'inline'
Info: Decision Tree (29): Decision Tree: The following object is masked from 'package:Rcpp':
Info: Decision Tree (29): Decision Tree: registerPlugin
Info: Decision Tree (29): Decision Tree: Warning messages:
Info: Decision Tree (29): Decision Tree: 1: In createDTParams(config, var_names) : NAs introduced by coercion
Info: Decision Tree (29): Decision Tree: 2: In adjustCP.rpart(model, config) : NAs introduced by coercion
Info: Decision Tree (29): Decision Tree: 3: In RColorBrewer::brewer.pal(l, "Set2") :
Info: Decision Tree (29): Decision Tree: minimal value for n is 3, returning requested palette with 3 different levels
Info: Decision Tree (29): Decision Tree: 4: In strwidth(title, cex = cex, units = "in") :
Info: Decision Tree (29): Decision Tree: font family 'yxfont' not found in PostScript font database
Info: Decision Tree (29): Decision Tree: 5: In readLines(x, warn = F) :
Info: Decision Tree (29): Decision Tree: invalid input found on input connection 'C:/Users/abdullah/AppData/Local/Alteryx/R-3.5.3/library/flightdeck/htmlwidgets/lib/bootbox/bootbox.min.js'
Info: Decision Tree (29): Tool #6: 1 records were True and 18 were False
Info: Decision Tree (29): Tool #7: 2 records were True and 17 were False
Info: Decision Tree (29): Tool #8: 10 records were True and 9 were False
Info: Decision Tree (29): Tool #15: 1 records were True and 18 were False
Info: Decision Tree (29): Tool #37: 4 records were True and 15 were False
Info: Decision Tree (29): Tool #240: 0 records were True and 19 were False
File_Output: Browse (31): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_77cbd064d68142479b7024fec643f443_.yxdb|7 records
File_Output: Browse (30): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_e112301908f84355b623b03339cc7917_.yxdb|1 records
File_Output: Browse (32): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_93cdaab721ab42e98cc23105415b204c_.yxdb|1 records
Info: Decision Tree (29): Tool #290: R version 3.5.3 (2019-03-11) - x86_64
Info: Decision Tree (29): Tool #290: Loading required package: sysfonts
Info: Decision Tree (29): Tool #290: Loading required package: showtextdb
Info: Decision Tree (29): Tool #290: rgeos version: 0.4-2, (SVN revision 581)
Info: Decision Tree (29): Tool #290: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Decision Tree (29): Tool #290: Linking to sp version: 1.3-1
Info: Decision Tree (29): Tool #290: Polygon checking: TRUE
Info: Decision Tree (29): Tool #290: Attaching package: 'AlteryxPredictive'
Info: Decision Tree (29): Tool #290: The following object is masked from 'package:AlteryxRDataX':
Info: Decision Tree (29): Tool #290: XMSG
Info: Forest Model (35): Tool #98: 350 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Forest Model (35): Forest Model: R version 3.5.3 (2019-03-11) - x86_64
Info: Forest Model (35): Forest Model: Loading required package: sysfonts
Info: Forest Model (35): Forest Model: Loading required package: showtextdb
Info: Forest Model (35): Forest Model: rgeos version: 0.4-2, (SVN revision 581)
Info: Forest Model (35): Forest Model: GEOS runtime version: 3.6.1-CAPI-1.10.1
Info: Forest Model (35): Forest Model: Linking to sp version: 1.3-1
Info: Forest Model (35): Forest Model: Polygon checking: TRUE
Info: Forest Model (35): Forest Model: Attaching package: 'AlteryxPredictive'
Info: Forest Model (35): Forest Model: The following object is masked from 'package:AlteryxRDataX':
Info: Forest Model (35): Forest Model: XMSG
Info: Forest Model (35): Forest Model: randomForest 4.6-14
Info: Forest Model (35): Forest Model: Type rfNews() to see new features/changes/bug fixes.
Info: Forest Model (35): Forest Model: Attaching package: 'inline'
Info: Forest Model (35): Forest Model: The following object is masked from 'package:Rcpp':
Info: Forest Model (35): Forest Model: registerPlugin
Warning: Forest Model (35): 350 records were omitted due to missing values
Error: Forest Model (35): Forest Model: Error in randomForest.default(m, y, ...) :
Info: Forest Model (35): Forest Model: Need at least two classes to do classification.
Info: Forest Model (35): Forest Model: Calls: eval ... randomForest -> randomForest.formula -> randomForest.default
Error: Forest Model (35): Forest Model: Execution halted
Info: Forest Model (35): Tool #16: 0 records were True and 0 were False
Info: Forest Model (35): Tool #18: 0 records were True and 0 were False
Info: Forest Model (35): Tool #20: 0 records were True and 0 were False
Info: Forest Model (35): Tool #22: 0 records were True and 0 were False
Info: Forest Model (35): Tool #24: 0 records were True and 0 were False
Info: Forest Model (35): Tool #64: 0 records were output
Info: Forest Model (35): Tool #54: 0 records were True and 0 were False
File_Output: Browse (37): C:\Users\abdullah\AppData\Local\Temp\Engine_4536_dd7926edefc049cdbb8dbfd82672a375_\Engine_5576_c65bea14b47c4ec4a96878d0706ababe_.yxdb|2 records
Error: Forest Model (35): Forest Model: The R.exe exit code (1) indicated an error.
Info: Create Samples (4): Tool #46: 150 records were True and 0 were False
End: Designer x64: Finished running Project 4 fixed.yxmd in 51.4 seconds with 6 errors and 15 warnings

AndrewKramer
Alteryx Alumni (Retired)

The issue is that after dropping missing values, your target has only one level. You need at least two for classification

 

Forest Model: Need at least two classes to do classification.
danilang
19 - Altair
19 - Altair

Hi @dalilo99 

 

Your Imputation tool is configured to Output Imputed Values as a separate field.  This gives you 3 age fields that you're passing to the predictive tools

 

i.png

Age-years is the original field and the imputed age column( with the hyphen) is the field that shows value replaced with imputed values and the second one is the output field.  The first field is completely blank and that's causing both the Boosted and Forest model to choke.   Remove this one from the predictor fields in the models.  Of the two remaining age fields, you should only use one, because they're redundant.    

 

Also...In your imputation tool, you're replacing nulls with the median value but there are no nulls in your data set.  Logically you should be replacing the 0 ages with the median, since 0 is not a valid value for age.

 

Dan

dalilo99
6 - Meteoroid

Dear Dan,

 

Thank you for your thorough solution, I appreciate you putting time into fixing this problem.

This method worked out pretty well!

Thank you so much!

dalilo99
6 - Meteoroid

Dear Andrew,

 

Thank you for your reply, i appreicate your help immensely!

 

-Dalal

Labels